package com.zdsoft.crm.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.zdsoft.crm.vo.ContractCountVo;
/**
 * 统计图
 * @author Administrator
 *
 */
public interface IContractMapper {

	@Select("select t.Date_Of_Contract dateOfContract,count(t.id) numCount from CONTRACT t "
			+ "where t.Date_Of_Contract >= to_date(#{firstDayOfWeek},'yyyy-MM-dd') "
			+ "and t.Date_Of_Contract <=  to_date(#{lastDayOfWeek},'yyyy-MM-dd') " + "group by t.Date_Of_Contract")
	public List<ContractCountVo> contractCount(@Param("firstDayOfWeek") String firstDayOfWeek,
			@Param("lastDayOfWeek") String lastDayOfWeek);

}
